RP2 Clinical Dataset

Ultra-Comprehensive Data Analysis Report

Table of Contents

1. Executive Summary

Total Studies: 19

Total Records: 11,236

Total Unique Biomarkers/Variables: 183

2. Complete Biomarker Catalog

This section lists EVERY biomarker and variable found across ALL studies, with complete statistics.

Hiv (3 variables)

VariableTotal NStudiesMean RangeOverall RangeAvg Completeness
CD4 Count1,3672201.67 - 633.522.00 - 1596.0098.9%
Antiretroviral Therapy Status3051N/AN/A100.0%
PCR - HIV Viral Load Roche30517.16 - 7.160.00 - 63.00100.0%

Haematology (14 variables)

VariableTotal NStudiesMean RangeOverall RangeAvg Completeness
HEMOGLOBIN1,367212.80 - 13.585.40 - 20.5099.1%
WBC1,36724.25 - 5.441.20 - 15.8599.1%
NEUTROPHILS1,36722.57 - 5.700.39 - 71.1099.1%
LYMPHOCYTES1,36722.27 - 4.150.25 - 53.1099.1%
PLATELET COUNT1,3512230.56 - 264.9119.00 - 747.0098.3%
HEMATOCRIT1,066116.86 - 16.860.19 - 60.3099.4%
Erythrocytes30214.33 - 4.332.72 - 6.5599.0%
MONOCYTES30110.40 - 0.400.14 - 0.9498.7%
EOSINOPHILS30110.13 - 0.130.00 - 0.7498.7%
BASOPHILS30110.03 - 0.030.00 - 0.1998.7%
MCV (MEAN CELL VOLUME)301196.50 - 96.5060.50 - 121.1098.7%
Mean Cell Haemoglobin301131.77 - 31.7718.20 - 42.6098.7%
Mean Cell Haemoglobin Concentration301132.86 - 32.8629.70 - 38.1098.7%
RDW301114.60 - 14.6011.90 - 23.9098.7%

Uncategorized (135 variables)

VariableTotal NStudiesMean RangeOverall RangeAvg Completeness
heat_completeness10,180100.60 - 1.000.07 - 1.00100.0%
BMI3,387423.80 - 1601.4214.60 - 850000.0098.6%
CD4 cell count2,2731687.85 - 687.853.00 - 9999.0089.1%
pulse_rate2,129172.50 - 72.5043.00 - 120.00100.0%
bmi2,128124.98 - 24.9814.00 - 40.60100.0%
oxygen_saturation2,127197.99 - 97.9989.00 - 100.0099.9%
respiratory_rate2,123117.85 - 17.8511.00 - 52.0099.7%
waist circumference1,576294.79 - 893.620.00 - 9150.0085.9%
treatment_arm1,18232.37 - 2.371.00 - 4.00100.0%
adverse_event_type1,18214.20 - 4.201.00 - 8.00100.0%
study_drug_related1,18211.92 - 1.921.00 - 8.00100.0%
total_adverse_events1,18213.70 - 3.701.00 - 19.00100.0%
serious_adverse_event1,18210.00 - 0.000.00 - 1.00100.0%
days_in_study1,1761855.07 - 855.0719.00 - 2295.0099.5%
CD4 cell count - enrollment1,1081402.63 - 402.632.00 - 9999.0043.5%
SYSTOLIC BLOOD PRESSURE1,0701118.28 - 118.2878.00 - 180.0099.8%
DIASTOLIC BLOOD PRESSURE1,070172.92 - 72.9240.00 - 123.0099.8%
HEART RATE1,069180.50 - 80.5050.00 - 160.0099.7%
ORAL TEMPERATURE1,068136.52 - 36.5234.20 - 39.9099.6%
HIV Viral Load1,0671248208.77 - 248208.77418.00 - 10000001.0099.5%
hip circumference9981106.37 - 106.370.00 - 173.8798.5%
visit_timepoint78418.84 - 8.840.00 - 24.00100.0%
study_week58550.00 - 0.000.00 - 0.00100.0%
CD4 cell count - at ART start4971333.30 - 333.300.00 - 9999.0019.5%
Height (cm)4511160.83 - 160.83142.00 - 184.00100.0%
Weight (kg)451164.67 - 64.6735.30 - 154.00100.0%
Creatinine clearance (mL/min)4511106.78 - 106.7871.00 - 174.00100.0%
HIV viral load408112477736.58 - 12477736.580.00 - 99999999.0016.0%
visit_number4011201.00 - 201.00201.00 - 201.00100.0%
enrollment_year40112015.61 - 2015.612015.00 - 2016.00100.0%
hemoglobin401115.25 - 15.257.30 - 19.30100.0%
hematocrit401145.85 - 45.8525.50 - 57.80100.0%
mean corpuscular volume401188.12 - 88.1258.00 - 107.00100.0%
white blood cell count40115.59 - 5.592.20 - 14.90100.0%
neutrophil percentage40112891.66 - 2891.66780.00 - 11234.00100.0%
lymphocyte percentage40112067.56 - 2067.56720.00 - 4310.00100.0%
monocyte percentage4011362.63 - 362.6352.00 - 1780.00100.0%
eosinophil percentage4011212.67 - 212.670.00 - 1910.00100.0%
basophil percentage401158.48 - 58.480.00 - 980.00100.0%
total_bilirubin40110.62 - 0.620.10 - 5.50100.0%
phosphorus40113.44 - 3.440.30 - 12.10100.0%
platelet count4001251.93 - 251.9363.00 - 2582.0099.8%
age_first_sex396118.29 - 18.297.00 - 38.0098.8%
CD4 cell count - latest3161456.76 - 456.766.00 - 9999.0012.4%
CD4 cell count - lowest3161342.16 - 342.165.00 - 936.0012.4%
last_weight_recorded285179.61 - 79.6143.00 - 150.0051.2%
last_height_recorded28011.63 - 1.631.31 - 1.9150.3%
Hemoglobin (g/dL)267411.78 - 12.008.00 - 15.00100.0%
Hematocrit (%)267427.40 - 29.170.00 - 58.00100.0%
White blood cell count (×10³/µL)26744.23 - 4.661.60 - 11.00100.0%
Platelet count (×10³/µL)26743.00 - 3.003.00 - 3.00100.0%
ALT (U/L)26741.00 - 1.121.00 - 2.00100.0%
AST (U/L)255458.61 - 59.9211.10 - 84.6096.1%
Creatinine (mg/dL)14830.65 - 0.650.40 - 0.9032.8%
creatinine10410.79 - 0.790.40 - 1.1525.9%
HIV viral load - latest88112497579.86 - 12497579.860.00 - 99999999.003.5%
HIV viral load (copies/mL)782400.00 - 400.00400.00 - 400.00100.0%
neurological_assessment_available7811.00 - 1.001.00 - 1.00100.0%
total_follow_up_weeks781172.72 - 172.7216.00 - 212.00100.0%
visit_date09N/AN/AN/A
province08N/AN/AN/A
CD4 cell count (cells/µL)02N/AN/AN/A
HIV viral load suppression02N/AN/AN/A
study_completion_status03N/AN/AN/A
date of birth01N/AN/AN/A
site_name01N/AN/AN/A
facility_name01N/AN/AN/A
town01N/AN/AN/A
HIV viral load status01N/AN/AN/A
date_care_entry01N/AN/AN/A
date_art_start01N/AN/AN/A
education_level02N/AN/AN/A
employment_status02N/AN/AN/A
marital_status02N/AN/AN/A
monthly_income02N/AN/AN/A
housing_type01N/AN/AN/A
medical_insurance01N/AN/AN/A
visit_name01N/AN/AN/A
diabetes mellitus02N/AN/AN/A
hypertension02N/AN/AN/A
asthma01N/AN/AN/A
covid-1901N/AN/AN/A
obesity01N/AN/AN/A
enrollment_date01N/AN/AN/A
adverse_event_date01N/AN/AN/A
jhu_report_date01N/AN/AN/A
adverse_event_grade01N/AN/AN/A
gender_identity01N/AN/AN/A
ethnicity01N/AN/AN/A
HIV test result02N/AN/AN/A
HIV-1 test result01N/AN/AN/A
HIV-2 test result01N/AN/AN/A
urine_protein01N/AN/AN/A
urine_glucose01N/AN/AN/A
syphilis_result01N/AN/AN/A
gonorrhea_result01N/AN/AN/A
chlamydia_result01N/AN/AN/A
hepatitis_A01N/AN/AN/A
hepatitis_B01N/AN/AN/A
religion01N/AN/AN/A
household_size01N/AN/AN/A
sexual_identity01N/AN/AN/A
sexual_attraction01N/AN/AN/A
gender_expression01N/AN/AN/A
sexual_orientation_disclosure01N/AN/AN/A
stigma_harassment01N/AN/AN/A
stigma_violence01N/AN/AN/A
stigma_discrimination01N/AN/AN/A
stigma_healthcare01N/AN/AN/A
stigma_avoidance01N/AN/AN/A
social_support_money01N/AN/AN/A
social_support_clinic01N/AN/AN/A
social_support_talk01N/AN/AN/A
social_support_food01N/AN/AN/A
circumcision_status01N/AN/AN/A
circumcision_type01N/AN/AN/A
enrollment_completed01N/AN/AN/A
blood_collection01N/AN/AN/A
urine_collection01N/AN/AN/A
swab_collection01N/AN/AN/A
hiv_testing_done01N/AN/AN/A
Syphilis test result01N/AN/AN/A
Gonorrhea test result01N/AN/AN/A
Chlamydia test result01N/AN/AN/A
Trichomonas test result01N/AN/AN/A
vaccination_date01N/AN/AN/A
vaccination_site01N/AN/AN/A
vaccination_route01N/AN/AN/A
HIV status01N/AN/AN/A
Hyperlipidaemia01N/AN/AN/A
cohort01N/AN/AN/A
HIV ART Status01N/AN/AN/A
TRANSFERRIN01N/AN/AN/A
dyslipidemia01N/AN/AN/A
tuberculosis01N/AN/AN/A

Blood Chemistry (17 variables)

VariableTotal NStudiesMean RangeOverall RangeAvg Completeness
FASTING HDL3,03541.12 - 16.880.10 - 89.3296.2%
FASTING LDL3,03441.68 - 40.020.00 - 190.1496.2%
FASTING TOTAL CHOLESTEROL3,03444.12 - 65.871.12 - 251.9396.2%
FASTING GLUCOSE2,75044.94 - 36.350.95 - 295.0071.9%
ALBUMIN1,986337.61 - 41.691.70 - 60.0063.6%
AST1,737322.83 - 32.1210.00 - 326.0098.7%
ALT1,737320.81 - 25.065.00 - 465.0098.7%
CREATININE1,335238.40 - 63.780.42 - 237.0098.0%
POTASSIUM1,22324.30 - 4.821.05 - 6.6098.1%
ALKALINE PHOSPHATASE1,031281.82 - 81.8230.00 - 946.0048.1%
SODIUM1,0311136.41 - 136.41122.00 - 147.0096.2%
TOTAL BILIRUBIN1,03113.61 - 3.610.10 - 77.4096.2%
FASTING TRIGLYCERIDES98611.04 - 1.040.22 - 10.4297.3%
TOTAL PROTEIN937254.94 - 54.9412.09 - 261.2546.2%
creatinine clearance3051128.88 - 128.8840.00 - 243.00100.0%
CALCIUM112.31 - 2.312.31 - 2.310.3%
LDH01N/AN/A0.0%

Physical Examination (7 variables)

VariableTotal NStudiesMean RangeOverall RangeAvg Completeness
weight5,669763.20 - 79.6434.00 - 200.0085.0%
systolic blood pressure4,0024118.50 - 132.3081.00 - 258.5092.8%
diastolic blood pressure4,002475.20 - 88.4040.00 - 150.0092.8%
oral temperature2,481336.25 - 36.4934.10 - 37.7075.3%
respiration rate1,424316.56 - 17.9412.00 - 22.0075.2%
heart rate355270.23 - 78.0050.00 - 110.0063.0%
Other measures of obesity354226.53 - 27.9117.51 - 47.3962.9%

Static Variables (7 variables)

VariableTotal NStudiesMean RangeOverall RangeAvg Completeness
Age (at enrolment)8,8511120.84 - 53.5115.00 - 76.0097.6%
date7,1918N/AN/A99.3%
Height5,66671.27 - 167.000.01 - 197.0084.9%
Sex5,06712N/AN/A99.7%
Race4,0554N/AN/A99.6%
Country49711N/AN/A100.0%
Clinical Study ID1921N/AN/A100.0%

3. Biomarker Coverage Matrix Across Studies

This matrix shows which studies have which biomarkers, with completeness percentages. Use this to identify data gaps.

BiomarkerCategoryTotal NACTG_015ACTG_016ACTG_017ACTG_018ACTG_019ACTG_021Aurum_009DPHRU_013DPHRU_053EZIN_025Ezin_002IMPAACT_010JHSPH_005SCHARP_004SCHARP_006VIDA_007VIDA_008WRHI_001WRHI_003
ALBUMINblood chemistry1,986--------94%--------96%0%
ALKALINE PHOSPHATASEblood chemistry1,031-----------------96%0%
ALTblood chemistry1,737-------------100%---96%100%
ALT (U/L)Uncategorized267100%100%-0%100%--------------
ASTblood chemistry1,737-------------100%---96%100%
AST (U/L)Uncategorized255100%100%-0%88%--------------
Age (at enrolment)static variables8,8510%0%----100%98%100%----100%100%82%99%100%100%
Antiretroviral Therapy StatusHIV305------------------100%
BASOPHILSHaematology301------------------99%
BMIUncategorized3,387-------98%99%-------97%100%-
CALCIUMblood chemistry1------------------0%
CD4 CountHIV1,367-----------------100%98%
CD4 cell countUncategorized2,273------89%------------
CD4 cell count (cells/µL)Uncategorized00%0%-----------------
CD4 cell count - at ART startUncategorized497------19%------------
CD4 cell count - enrollmentUncategorized1,108------43%------------
CD4 cell count - latestUncategorized316------12%------------
CD4 cell count - lowestUncategorized316------12%------------
CREATININEblood chemistry1,335-----------------96%100%
Chlamydia test resultUncategorized0--------------0%----
Clinical Study IDstatic variables192---------100%---------
Countrystatic variables4970%0%0%0%0%0%0%--100%---0%0%---100%
Creatinine (mg/dL)Uncategorized1480%0%------------33%----
Creatinine clearance (mL/min)Uncategorized451--------------100%----
DIASTOLIC BLOOD PRESSUREUncategorized1,070-----------------100%-
EOSINOPHILSHaematology301------------------99%
ErythrocytesHaematology302------------------99%
FASTING GLUCOSEblood chemistry2,750-------96%98%--------94%0%
FASTING HDLblood chemistry3,035-------92%97%--------95%100%
FASTING LDLblood chemistry3,034-------92%97%--------95%100%
FASTING TOTAL CHOLESTEROLblood chemistry3,034-------92%97%--------95%100%
FASTING TRIGLYCERIDESblood chemistry986--------97%----------
Gonorrhea test resultUncategorized0--------------0%----
HEART RATEUncategorized1,069-----------------100%-
HEMATOCRITHaematology1,066-----------------99%-
HEMOGLOBINHaematology1,367-----------------99%99%
HIV ART StatusUncategorized0-----------------0%-
HIV Viral LoadUncategorized1,067-----------------100%-
HIV statusUncategorized0----------------0%--
HIV test resultUncategorized0-------------0%0%----
HIV viral loadUncategorized408------16%------------
HIV viral load (copies/mL)Uncategorized780%100%-----------------
HIV viral load - latestUncategorized88------3%------------
HIV viral load statusUncategorized0------0%------------
HIV viral load suppressionUncategorized00%0%-----------------
HIV-1 test resultUncategorized0-------------0%-----
HIV-2 test resultUncategorized0-------------0%-----
Heightstatic variables5,666-------72%99%26%-----100%97%100%100%
Height (cm)Uncategorized451--------------100%----
Hematocrit (%)Uncategorized267100%100%-0%100%--------------
Hemoglobin (g/dL)Uncategorized267100%100%-0%100%--------------
HyperlipidaemiaUncategorized0----------------0%--
LDHblood chemistry0------------------0%
LYMPHOCYTESHaematology1,367-----------------99%99%
MCV (MEAN CELL VOLUME)Haematology301------------------99%
MONOCYTESHaematology301------------------99%
Mean Cell HaemoglobinHaematology301------------------99%
Mean Cell Haemoglobin ConcentrationHaematology301------------------99%
NEUTROPHILSHaematology1,367-----------------99%99%
ORAL TEMPERATUREUncategorized1,068-----------------100%-
Other measures of obesityphysical examination354---------26%--------100%
PCR - HIV Viral Load RocheHIV305------------------100%
PLATELET COUNTHaematology1,351-----------------98%99%
POTASSIUMblood chemistry1,223---------100%-------96%-
Platelet count (×10³/µL)Uncategorized267100%100%-0%100%--------------
RDWHaematology301------------------99%
Racestatic variables4,055---------------100%99%100%100%
SODIUMblood chemistry1,031-----------------96%-
SYSTOLIC BLOOD PRESSUREUncategorized1,070-----------------100%-
Sexstatic variables5,0670%0%-0%0%-0%-100%----0%0%100%99%100%100%
Syphilis test resultUncategorized0--------------0%----
TOTAL BILIRUBINblood chemistry1,031-----------------96%-
TOTAL PROTEINblood chemistry937--------92%---------0%
TRANSFERRINUncategorized0------------------0%
Trichomonas test resultUncategorized0--------------0%----
WBCHaematology1,367-----------------99%99%
Weight (kg)Uncategorized451--------------100%----
White blood cell count (×10³/µL)Uncategorized267100%100%-0%100%--------------
adverse_event_dateUncategorized0------------0%------
adverse_event_gradeUncategorized0------------0%------
adverse_event_typeUncategorized1,182------------100%------
age_first_sexUncategorized396-------------99%-----
asthmaUncategorized0---------0%---------
basophil percentageUncategorized401-------------100%-----
blood_collectionUncategorized0-------------0%-----
bmiUncategorized2,128---------------100%---
chlamydia_resultUncategorized0-------------0%-----
circumcision_statusUncategorized0-------------0%-----
circumcision_typeUncategorized0-------------0%-----
cohortUncategorized0----------------0%--
covid-19Uncategorized0---------0%---------
creatinineUncategorized104-------------26%-----
creatinine clearanceblood chemistry305------------------100%
datestatic variables7,191-------98%99%100%--100%--100%99%100%100%
date of birthUncategorized0------0%------------
date_art_startUncategorized0------0%------------
date_care_entryUncategorized0------0%------------
days_in_studyUncategorized1,176------------99%------
diabetes mellitusUncategorized0---------0%--------0%
diastolic blood pressurephysical examination4,002-------72%99%------100%--100%
dyslipidemiaUncategorized0------------------0%
education_levelUncategorized0------0%------0%-----
employment_statusUncategorized0------0%------0%-----
enrollment_completedUncategorized0-------------0%-----
enrollment_dateUncategorized0------------0%------
enrollment_yearUncategorized401-------------100%-----
eosinophil percentageUncategorized401-------------100%-----
ethnicityUncategorized0-------------0%-----
facility_nameUncategorized0------0%------------
gender_expressionUncategorized0-------------0%-----
gender_identityUncategorized0-------------0%-----
gonorrhea_resultUncategorized0-------------0%-----
heart ratephysical examination355---------26%--------100%
heat_completenessUncategorized10,180------100%100%100%100%--100%100%-100%100%100%100%
hematocritUncategorized401-------------100%-----
hemoglobinUncategorized401-------------100%-----
hepatitis_AUncategorized0-------------0%-----
hepatitis_BUncategorized0-------------0%-----
hip circumferenceUncategorized998--------99%----------
hiv_testing_doneUncategorized0-------------0%-----
household_sizeUncategorized0-------------0%-----
housing_typeUncategorized0------0%------------
hypertensionUncategorized0---------0%--------0%
jhu_report_dateUncategorized0------------0%------
last_height_recordedUncategorized280----------------50%--
last_weight_recordedUncategorized285----------------51%--
lymphocyte percentageUncategorized401-------------100%-----
marital_statusUncategorized0------0%------0%-----
mean corpuscular volumeUncategorized401-------------100%-----
medical_insuranceUncategorized0------0%------------
monocyte percentageUncategorized401-------------100%-----
monthly_incomeUncategorized0------0%------0%-----
neurological_assessment_availableUncategorized78-----100%-------------
neutrophil percentageUncategorized401-------------100%-----
obesityUncategorized0---------0%---------
oral temperaturephysical examination2,481---------26%-----100%--100%
oxygen_saturationUncategorized2,127---------------100%---
phosphorusUncategorized401-------------100%-----
platelet countUncategorized400-------------100%-----
provinceUncategorized00%0%0%0%0%0%0%-------0%----
pulse_rateUncategorized2,129---------------100%---
religionUncategorized0-------------0%-----
respiration ratephysical examination1,424---------26%-------100%100%
respiratory_rateUncategorized2,123---------------100%---
serious_adverse_eventUncategorized1,182------------100%------
sexual_attractionUncategorized0-------------0%-----
sexual_identityUncategorized0-------------0%-----
sexual_orientation_disclosureUncategorized0-------------0%-----
site_nameUncategorized0------0%------------
social_support_clinicUncategorized0-------------0%-----
social_support_foodUncategorized0-------------0%-----
social_support_moneyUncategorized0-------------0%-----
social_support_talkUncategorized0-------------0%-----
stigma_avoidanceUncategorized0-------------0%-----
stigma_discriminationUncategorized0-------------0%-----
stigma_harassmentUncategorized0-------------0%-----
stigma_healthcareUncategorized0-------------0%-----
stigma_violenceUncategorized0-------------0%-----
study_completion_statusUncategorized00%0%---0%-------------
study_drug_relatedUncategorized1,182------------100%------
study_weekUncategorized585100%100%-100%100%100%-------------
swab_collectionUncategorized0-------------0%-----
syphilis_resultUncategorized0-------------0%-----
systolic blood pressurephysical examination4,002-------72%99%------100%--100%
total_adverse_eventsUncategorized1,182------------100%------
total_bilirubinUncategorized401-------------100%-----
total_follow_up_weeksUncategorized78-----100%-------------
townUncategorized0------0%------------
treatment_armUncategorized1,1820%0%----------100%------
tuberculosisUncategorized0------------------0%
urine_collectionUncategorized0-------------0%-----
urine_glucoseUncategorized0-------------0%-----
urine_proteinUncategorized0-------------0%-----
vaccination_dateUncategorized0---------------0%---
vaccination_routeUncategorized0---------------0%---
vaccination_siteUncategorized0---------------0%---
visit_dateUncategorized00%0%0%0%0%0%0%------0%0%----
visit_nameUncategorized0-------0%-----------
visit_numberUncategorized401-------------100%-----
visit_timepointUncategorized784-------100%-----------
waist circumferenceUncategorized1,576-------72%100%----------
weightphysical examination5,669-------72%99%26%-----100%98%100%100%
white blood cell countUncategorized401-------------100%-----

4. Individual Study Profiles with Visualizations

Complete profiles for each study with embedded distribution plots.

JHB_ACTG_015

Full Name: ACTG_5208_Nevirapine_Lopinavir_Trial

Study Type: Randomized Clinical Trial

Records: 177

Participants: 87

Variables Harmonized: 18

Distribution Plots

Jhb Actg 015 All Distributions

JHB_ACTG_015_ALL_distributions

Jhb Actg 015 Biomarker Distributions

JHB_ACTG_015_biomarker_distributions

Missing Data Analysis

JHB_ACTG_015_missing_data
JHB_ACTG_015_missing_data_ALL

Categorical Variables

Jhb Actg 015 Categorical All Page1

JHB_ACTG_015_categorical_ALL_page1

Jhb Actg 015 Categorical All Page2

JHB_ACTG_015_categorical_ALL_page2

Jhb Actg 015 Categorical All Page3

JHB_ACTG_015_categorical_ALL_page3

JHB_ACTG_016

Full Name: ACTG_5221_HIV_TB_Coinfection_Trial

Study Type: Randomized Clinical Trial

Records: 78

Participants: 76

Variables Harmonized: 19

Distribution Plots

Jhb Actg 016 All Distributions

JHB_ACTG_016_ALL_distributions

Jhb Actg 016 Biomarker Distributions

JHB_ACTG_016_biomarker_distributions

Missing Data Analysis

JHB_ACTG_016_missing_data
JHB_ACTG_016_missing_data_ALL

Categorical Variables

Jhb Actg 016 Categorical All Page1

JHB_ACTG_016_categorical_ALL_page1

Jhb Actg 016 Categorical All Page2

JHB_ACTG_016_categorical_ALL_page2

Jhb Actg 016 Categorical All Page3

JHB_ACTG_016_categorical_ALL_page3

JHB_ACTG_017

Full Name: Unknown

Study Type: Unknown

Records: 0

Participants: 0

Variables Harmonized: 7

Distribution Plots

No distribution plots available for this study.

Missing Data Analysis

JHB_ACTG_017_missing_data

Categorical Variables

Jhb Actg 017 Categorical All

JHB_ACTG_017_categorical_ALL

JHB_ACTG_018

Full Name: ACTG_5271_Neurological_Study

Study Type: Clinical Trial

Records: 0

Participants: 0

Variables Harmonized: 9

Distribution Plots

Jhb Actg 018 Biomarker Distributions

JHB_ACTG_018_biomarker_distributions

Missing Data Analysis

JHB_ACTG_018_missing_data
JHB_ACTG_018_missing_data_ALL

Categorical Variables

Jhb Actg 018 Categorical All Page1

JHB_ACTG_018_categorical_ALL_page1

Jhb Actg 018 Categorical All Page2

JHB_ACTG_018_categorical_ALL_page2

JHB_ACTG_019

Full Name: ACTG_5175_Treatment_Study

Study Type: Clinical Trial

Records: 0

Participants: 0

Variables Harmonized: 15

Distribution Plots

Jhb Actg 019 All Distributions

JHB_ACTG_019_ALL_distributions

Jhb Actg 019 Biomarker Distributions

JHB_ACTG_019_biomarker_distributions

Missing Data Analysis

JHB_ACTG_019_missing_data
JHB_ACTG_019_missing_data_ALL

Categorical Variables

Jhb Actg 019 Categorical All Page1

JHB_ACTG_019_categorical_ALL_page1

Jhb Actg 019 Categorical All Page2

JHB_ACTG_019_categorical_ALL_page2

JHB_ACTG_021

Full Name: ACTG_5199_International_Neurological_Study

Study Type: Neurological Assessment

Records: 671

Participants: 78

Variables Harmonized: 12

Distribution Plots

Jhb Actg 021 All Distributions

JHB_ACTG_021_ALL_distributions

Missing Data Analysis

JHB_ACTG_021_missing_data

Categorical Variables

Jhb Actg 021 Categorical All

JHB_ACTG_021_categorical_ALL

JHB_Aurum_009

Full Name: Tholimpilo_HIV_Linkage_Study

Study Type: Hiv Linkage Care Program

Description: Multi-site HIV testing and linkage to care program evaluation

Records: 2,930

Participants: 2,551

Variables Harmonized: 4

Distribution Plots

Jhb Aurum 009 All Distributions

JHB_Aurum_009_ALL_distributions

Jhb Aurum 009 Biomarker Distributions

JHB_Aurum_009_biomarker_distributions

Missing Data Analysis

JHB_Aurum_009_missing_data
JHB_Aurum_009_missing_data_ALL

Categorical Variables

Jhb Aurum 009 Categorical All Page1

JHB_Aurum_009_categorical_ALL_page1

Jhb Aurum 009 Categorical All Page2

JHB_Aurum_009_categorical_ALL_page2

Jhb Aurum 009 Categorical All Page3

JHB_Aurum_009_categorical_ALL_page3

JHB_DPHRU_013

Full Name: WBS_Longitudinal

Study Type: Unknown

Records: 784

Participants: 0

Variables Harmonized: 11

Distribution Plots

Jhb Dphru 013 All Distributions

JHB_DPHRU_013_ALL_distributions

Jhb Dphru 013 Biomarker Distributions

JHB_DPHRU_013_biomarker_distributions

Missing Data Analysis

JHB_DPHRU_013_missing_data
JHB_DPHRU_013_missing_data_ALL

Categorical Variables

Jhb Dphru 013 Categorical All Page1

JHB_DPHRU_013_categorical_ALL_page1

Jhb Dphru 013 Categorical All Page2

JHB_DPHRU_013_categorical_ALL_page2

JHB_DPHRU_053

Full Name: MASC

Study Type: Unknown

Records: 1,013

Participants: 0

Variables Harmonized: 15

Distribution Plots

Jhb Dphru 053 All Distributions Page1

JHB_DPHRU_053_ALL_distributions_page1

Jhb Dphru 053 All Distributions Page2

JHB_DPHRU_053_ALL_distributions_page2

Jhb Dphru 053 Biomarker Distributions

JHB_DPHRU_053_biomarker_distributions

Missing Data Analysis

JHB_DPHRU_053_missing_data
JHB_DPHRU_053_missing_data_ALL

Categorical Variables

Jhb Dphru 053 Categorical All

JHB_DPHRU_053_categorical_ALL

JHB_EZIN_025

Full Name: EZIN025_COVID19_Treatment_Trial

Study Type: Covid19 Randomized Trial

Description: COVID-19 treatment trial with 5 treatment arms

Records: 192

Participants: 192

Variables Harmonized: 11

Distribution Plots

Jhb Ezin 025 All Distributions

JHB_EZIN_025_ALL_distributions

Jhb Ezin 025 Biomarker Distributions

JHB_EZIN_025_biomarker_distributions

Missing Data Analysis

JHB_EZIN_025_missing_data
JHB_EZIN_025_missing_data_ALL

Categorical Variables

Jhb Ezin 025 Categorical All Page1

JHB_EZIN_025_categorical_ALL_page1

Jhb Ezin 025 Categorical All Page2

JHB_EZIN_025_categorical_ALL_page2

JHB_Ezin_002

Distribution Plots

No distribution plots available for this study.


JHB_IMPAACT_010

Distribution Plots

No distribution plots available for this study.


JHB_JHSPH_005

Full Name: Tuberculosis_Prevention_Trial

Study Type: Adverse Events Clinical Trial

Description: Limited HEAT mapping due to adverse events focus

Records: 1,182

Participants: 0

Variables Harmonized: 2

Distribution Plots

No distribution plots available for this study.

Missing Data Analysis

JHB_JHSPH_005_missing_data
JHB_JHSPH_005_missing_data_ALL

Categorical Variables

Jhb Jhsph 005 Categorical All Page1

JHB_JHSPH_005_categorical_ALL_page1

Jhb Jhsph 005 Categorical All Page2

JHB_JHSPH_005_categorical_ALL_page2

JHB_SCHARP_004

Full Name: HPTN_075_MSM_Prevention_Feasibility

Study Type: Hiv Prevention Feasibility

Description: Comprehensive MSM HIV prevention feasibility study with extensive biomarker and behavioral data

Records: 401

Participants: 401

Variables Harmonized: 6

Distribution Plots

Jhb Scharp 004 All Distributions Page1

JHB_SCHARP_004_ALL_distributions_page1

Jhb Scharp 004 All Distributions Page2

JHB_SCHARP_004_ALL_distributions_page2

Jhb Scharp 004 Biomarker Distributions

JHB_SCHARP_004_biomarker_distributions

Missing Data Analysis

JHB_SCHARP_004_missing_data
JHB_SCHARP_004_missing_data_ALL

Categorical Variables

Jhb Scharp 004 Categorical All Page1

JHB_SCHARP_004_categorical_ALL_page1

Jhb Scharp 004 Categorical All Page2

JHB_SCHARP_004_categorical_ALL_page2

Jhb Scharp 004 Categorical All Page3

JHB_SCHARP_004_categorical_ALL_page3

Jhb Scharp 004 Categorical All Page4

JHB_SCHARP_004_categorical_ALL_page4

Jhb Scharp 004 Categorical All Page5

JHB_SCHARP_004_categorical_ALL_page5

Jhb Scharp 004 Categorical All Page6

JHB_SCHARP_004_categorical_ALL_page6

Jhb Scharp 004 Categorical All Page7

JHB_SCHARP_004_categorical_ALL_page7

Jhb Scharp 004 Categorical All Page8

JHB_SCHARP_004_categorical_ALL_page8

JHB_SCHARP_006

Full Name: HPTN_082_PrEP_Young_Women

Study Type: Prep Feasibility

Records: 451

Participants: 451

Variables Harmonized: 19

Distribution Plots

Jhb Scharp 006 All Distributions

JHB_SCHARP_006_ALL_distributions

Jhb Scharp 006 Biomarker Distributions

JHB_SCHARP_006_biomarker_distributions

Missing Data Analysis

JHB_SCHARP_006_missing_data
JHB_SCHARP_006_missing_data_ALL

Categorical Variables

Jhb Scharp 006 Categorical All Page1

JHB_SCHARP_006_categorical_ALL_page1

Jhb Scharp 006 Categorical All Page2

JHB_SCHARP_006_categorical_ALL_page2

JHB_VIDA_007

Full Name: COVID_Vaccine_ChAdOx1_AstraZeneca

Study Type: Covid Vaccine Clinical Trial

Description: Multi-CSV integration with demographics, vitals, and vaccination data

Records: 2,129

Participants: 0

Variables Harmonized: 10

Distribution Plots

Jhb Vida 007 All Distributions

JHB_VIDA_007_ALL_distributions

Jhb Vida 007 Biomarker Distributions

JHB_VIDA_007_biomarker_distributions

Missing Data Analysis

JHB_VIDA_007_missing_data
JHB_VIDA_007_missing_data_ALL

Categorical Variables

Jhb Vida 007 Categorical All Page1

JHB_VIDA_007_categorical_ALL_page1

Jhb Vida 007 Categorical All Page2

JHB_VIDA_007_categorical_ALL_page2

JHB_VIDA_008

Full Name: COVID_Healthcare_Worker_Study

Study Type: Covid Hcw Longitudinal Cohort

Description: Multi-cohort healthcare worker study with baseline demographics and clinical measurements

Records: 557

Participants: 552

Variables Harmonized: 7

Distribution Plots

Jhb Vida 008 All Distributions

JHB_VIDA_008_ALL_distributions

Jhb Vida 008 Biomarker Distributions

JHB_VIDA_008_biomarker_distributions

Missing Data Analysis

JHB_VIDA_008_missing_data
JHB_VIDA_008_missing_data_ALL

Categorical Variables

Jhb Vida 008 Categorical All Page1

JHB_VIDA_008_categorical_ALL_page1

Jhb Vida 008 Categorical All Page2

JHB_VIDA_008_categorical_ALL_page2

JHB_WRHI_001

Full Name: WRHI001_Stavudine_vs_Tenofovir

Study Type: Hiv Art Randomized Trial

Description: HIV antiretroviral therapy clinical trial comparing stavudine vs tenofovir regimens

Records: 1,072

Participants: 1,072

Variables Harmonized: 27

Distribution Plots

Jhb Wrhi 001 All Distributions Page1

JHB_WRHI_001_ALL_distributions_page1

Jhb Wrhi 001 All Distributions Page2

JHB_WRHI_001_ALL_distributions_page2

Jhb Wrhi 001 All Distributions Page3

JHB_WRHI_001_ALL_distributions_page3

Jhb Wrhi 001 Biomarker Distributions

JHB_WRHI_001_biomarker_distributions

Missing Data Analysis

JHB_WRHI_001_missing_data
JHB_WRHI_001_missing_data_ALL

Categorical Variables

Jhb Wrhi 001 Categorical All Page1

JHB_WRHI_001_categorical_ALL_page1

Jhb Wrhi 001 Categorical All Page2

JHB_WRHI_001_categorical_ALL_page2

JHB_WRHI_003

Full Name: WRHI003_Darunavir_vs_Lopinavir

Study Type: Hiv Art Randomized Trial

Description: HIV antiretroviral therapy clinical trial comparing low-dose darunavir vs lopinavir regimens

Records: 305

Participants: 300

Variables Harmonized: 43

Distribution Plots

Jhb Wrhi 003 All Distributions Page1

JHB_WRHI_003_ALL_distributions_page1

Jhb Wrhi 003 All Distributions Page2

JHB_WRHI_003_ALL_distributions_page2

Jhb Wrhi 003 All Distributions Page3

JHB_WRHI_003_ALL_distributions_page3

Jhb Wrhi 003 Biomarker Distributions

JHB_WRHI_003_biomarker_distributions

Missing Data Analysis

JHB_WRHI_003_missing_data
JHB_WRHI_003_missing_data_ALL

Categorical Variables

Jhb Wrhi 003 Categorical All Page1

JHB_WRHI_003_categorical_ALL_page1

Jhb Wrhi 003 Categorical All Page2

JHB_WRHI_003_categorical_ALL_page2

Jhb Wrhi 003 Categorical All Page3

JHB_WRHI_003_categorical_ALL_page3

Jhb Wrhi 003 Categorical All Page4

JHB_WRHI_003_categorical_ALL_page4

5. Data Gap Analysis and Recommendations

Biomarkers with Limited Coverage (< 30% of studies)

BiomarkerAvailable InMissing From
neurological_assessment_available1 studies18 studies
total_follow_up_weeks1 studies18 studies
date of birth1 studies18 studies
site_name1 studies18 studies
facility_name1 studies18 studies
town1 studies18 studies
CD4 cell count1 studies18 studies
CD4 cell count - enrollment1 studies18 studies
CD4 cell count - latest1 studies18 studies
CD4 cell count - lowest1 studies18 studies
CD4 cell count - at ART start1 studies18 studies
HIV viral load1 studies18 studies
HIV viral load - latest1 studies18 studies
HIV viral load status1 studies18 studies
date_care_entry1 studies18 studies
date_art_start1 studies18 studies
housing_type1 studies18 studies
medical_insurance1 studies18 studies
visit_timepoint1 studies18 studies
visit_name1 studies18 studies
FASTING TRIGLYCERIDES1 studies18 studies
hip circumference1 studies18 studies
Clinical Study ID1 studies18 studies
asthma1 studies18 studies
covid-191 studies18 studies
obesity1 studies18 studies
enrollment_date1 studies18 studies
adverse_event_date1 studies18 studies
jhu_report_date1 studies18 studies
adverse_event_type1 studies18 studies
adverse_event_grade1 studies18 studies
study_drug_related1 studies18 studies
total_adverse_events1 studies18 studies
days_in_study1 studies18 studies
serious_adverse_event1 studies18 studies
visit_number1 studies18 studies
gender_identity1 studies18 studies
enrollment_year1 studies18 studies
ethnicity1 studies18 studies
HIV-1 test result1 studies18 studies
HIV-2 test result1 studies18 studies
hemoglobin1 studies18 studies
hematocrit1 studies18 studies
mean corpuscular volume1 studies18 studies
platelet count1 studies18 studies
white blood cell count1 studies18 studies
neutrophil percentage1 studies18 studies
lymphocyte percentage1 studies18 studies
monocyte percentage1 studies18 studies
eosinophil percentage1 studies18 studies
basophil percentage1 studies18 studies
creatinine1 studies18 studies
total_bilirubin1 studies18 studies
phosphorus1 studies18 studies
urine_protein1 studies18 studies
urine_glucose1 studies18 studies
syphilis_result1 studies18 studies
gonorrhea_result1 studies18 studies
chlamydia_result1 studies18 studies
hepatitis_A1 studies18 studies
hepatitis_B1 studies18 studies
religion1 studies18 studies
household_size1 studies18 studies
sexual_identity1 studies18 studies
sexual_attraction1 studies18 studies
gender_expression1 studies18 studies
sexual_orientation_disclosure1 studies18 studies
stigma_harassment1 studies18 studies
stigma_violence1 studies18 studies
stigma_discrimination1 studies18 studies
stigma_healthcare1 studies18 studies
stigma_avoidance1 studies18 studies
social_support_money1 studies18 studies
social_support_clinic1 studies18 studies
social_support_talk1 studies18 studies
social_support_food1 studies18 studies
age_first_sex1 studies18 studies
circumcision_status1 studies18 studies
circumcision_type1 studies18 studies
enrollment_completed1 studies18 studies
blood_collection1 studies18 studies
urine_collection1 studies18 studies
swab_collection1 studies18 studies
hiv_testing_done1 studies18 studies
Height (cm)1 studies18 studies
Weight (kg)1 studies18 studies
Creatinine clearance (mL/min)1 studies18 studies
Syphilis test result1 studies18 studies
Gonorrhea test result1 studies18 studies
Chlamydia test result1 studies18 studies
Trichomonas test result1 studies18 studies
pulse_rate1 studies18 studies
respiratory_rate1 studies18 studies
oxygen_saturation1 studies18 studies
bmi1 studies18 studies
vaccination_date1 studies18 studies
vaccination_site1 studies18 studies
vaccination_route1 studies18 studies
last_weight_recorded1 studies18 studies
last_height_recorded1 studies18 studies
HIV status1 studies18 studies
Hyperlipidaemia1 studies18 studies
cohort1 studies18 studies
SODIUM1 studies18 studies
TOTAL BILIRUBIN1 studies18 studies
HEMATOCRIT1 studies18 studies
HIV Viral Load1 studies18 studies
HIV ART Status1 studies18 studies
SYSTOLIC BLOOD PRESSURE1 studies18 studies
DIASTOLIC BLOOD PRESSURE1 studies18 studies
HEART RATE1 studies18 studies
ORAL TEMPERATURE1 studies18 studies
Antiretroviral Therapy Status1 studies18 studies
PCR - HIV Viral Load Roche1 studies18 studies
MONOCYTES1 studies18 studies
EOSINOPHILS1 studies18 studies
BASOPHILS1 studies18 studies
Erythrocytes1 studies18 studies
MCV (MEAN CELL VOLUME)1 studies18 studies
Mean Cell Haemoglobin1 studies18 studies
Mean Cell Haemoglobin Concentration1 studies18 studies
RDW1 studies18 studies
LDH1 studies18 studies
CALCIUM1 studies18 studies
creatinine clearance1 studies18 studies
TRANSFERRIN1 studies18 studies
dyslipidemia1 studies18 studies
tuberculosis1 studies18 studies
CD4 cell count (cells/µL)2 studies17 studies
HIV viral load (copies/mL)2 studies17 studies
HIV viral load suppression2 studies17 studies
education_level2 studies17 studies
employment_status2 studies17 studies
marital_status2 studies17 studies
monthly_income2 studies17 studies
waist circumference2 studies17 studies
TOTAL PROTEIN2 studies17 studies
heart rate2 studies17 studies
Other measures of obesity2 studies17 studies
POTASSIUM2 studies17 studies
diabetes mellitus2 studies17 studies
hypertension2 studies17 studies
HIV test result2 studies17 studies
CD4 Count2 studies17 studies
HEMOGLOBIN2 studies17 studies
CREATININE2 studies17 studies
ALKALINE PHOSPHATASE2 studies17 studies
WBC2 studies17 studies
PLATELET COUNT2 studies17 studies
NEUTROPHILS2 studies17 studies
LYMPHOCYTES2 studies17 studies
Creatinine (mg/dL)3 studies16 studies
treatment_arm3 studies16 studies
study_completion_status3 studies16 studies
ALBUMIN3 studies16 studies
oral temperature3 studies16 studies
respiration rate3 studies16 studies
AST3 studies16 studies
ALT3 studies16 studies
Hemoglobin (g/dL)4 studies15 studies
Hematocrit (%)4 studies15 studies
White blood cell count (×10³/µL)4 studies15 studies
Platelet count (×10³/µL)4 studies15 studies
AST (U/L)4 studies15 studies
ALT (U/L)4 studies15 studies
systolic blood pressure4 studies15 studies
diastolic blood pressure4 studies15 studies
FASTING GLUCOSE4 studies15 studies
FASTING HDL4 studies15 studies
FASTING LDL4 studies15 studies
FASTING TOTAL CHOLESTEROL4 studies15 studies
BMI4 studies15 studies
Race4 studies15 studies
study_week5 studies14 studies

High-Value Biomarkers (n ≥ 1000)

These 49 biomarkers have sufficient sample size for robust analysis: